from openpyxl import load_workbook

wb = load_workbook('test12.xlsx')
ws = wb.active
# print(ws.iter_cols(min_row=1, max_row=5, min_col=2))
print(list(ws.iter_cols(min_row=1, max_row=5, min_col=2)))
exit()
i = 1
for col in ws.iter_cols(min_row=1, max_row=5, min_col=2):
    # print(col)
    for c in col:
        # print(c)
        # 修改值
        # print(c.value)
        # 获取值
        c.value = c.value + str(i)
    i += 1
wb.save('test12.xlsx')
